
<!DOCTYPE html>
<!--[if lt IE 7]> <html lang="en" class="ie6" dir="ltr"
  xmlns:og="http://ogp.me/ns#"
  xmlns:fb="http://www.facebook.com/2008/fbml"
  xmlns:content="http://purl.org/rss/1.0/modules/content/"
  xmlns:dc="http://purl.org/dc/terms/"
  xmlns:foaf="http://xmlns.com/foaf/0.1/"
  xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
  xmlns:sioc="http://rdfs.org/sioc/ns#"
  xmlns:sioct="http://rdfs.org/sioc/types#"
  xmlns:skos="http://www.w3.org/2004/02/skos/core#"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema#"> <![endif]-->
<!--[if IE 7]>    <html lang="en" class="ie7" dir="ltr"
  xmlns:og="http://ogp.me/ns#"
  xmlns:fb="http://www.facebook.com/2008/fbml"
  xmlns:content="http://purl.org/rss/1.0/modules/content/"
  xmlns:dc="http://purl.org/dc/terms/"
  xmlns:foaf="http://xmlns.com/foaf/0.1/"
  xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
  xmlns:sioc="http://rdfs.org/sioc/ns#"
  xmlns:sioct="http://rdfs.org/sioc/types#"
  xmlns:skos="http://www.w3.org/2004/02/skos/core#"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema#"> <![endif]-->
<!--[if IE 8]>    <html lang="en" class="ie8" dir="ltr"
  xmlns:og="http://ogp.me/ns#"
  xmlns:fb="http://www.facebook.com/2008/fbml"
  xmlns:content="http://purl.org/rss/1.0/modules/content/"
  xmlns:dc="http://purl.org/dc/terms/"
  xmlns:foaf="http://xmlns.com/foaf/0.1/"
  xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
  xmlns:sioc="http://rdfs.org/sioc/ns#"
  xmlns:sioct="http://rdfs.org/sioc/types#"
  xmlns:skos="http://www.w3.org/2004/02/skos/core#"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema#"> <![endif]-->
<!--[if gt IE 8]><!--> <html lang="en" dir="ltr"
  xmlns:og="http://ogp.me/ns#"
  xmlns:fb="http://www.facebook.com/2008/fbml"
  xmlns:content="http://purl.org/rss/1.0/modules/content/"
  xmlns:dc="http://purl.org/dc/terms/"
  xmlns:foaf="http://xmlns.com/foaf/0.1/"
  xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
  xmlns:sioc="http://rdfs.org/sioc/ns#"
  xmlns:sioct="http://rdfs.org/sioc/types#"
  xmlns:skos="http://www.w3.org/2004/02/skos/core#"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema#"> <![endif]-->
<head profile="http://www.w3.org/1999/xhtml/vocab">
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta property="fb:app_id" content="182804048434364" />
<meta content="Database Drupal API examples" about="/database-drupal-api-examples" property="dc:title" />
<link rel="shortcut icon" href="http://www.mousewheel.net/sites/default/files/touchpro/icon4.png" type="image/png" />
<meta property="og:site_name" content="Mouse Wheel" />
<link rel="shortlink" href="/node/424" />
<meta name="Generator" content="Drupal 7 (http://drupal.org)" />
<link href="http://fonts.googleapis.com/css?family=Sue+Ellen+Francisco:" rel="stylesheet" type="text/css" />
<link rel="canonical" href="/database-drupal-api-examples" />
<meta property="og:title" content="Database Drupal API examples" />
  <title>Database Drupal API examples | Mouse Wheel</title>
  <script>window.piePath = "/sites/all/themes/arctica/arctica/features/arctica-cssfuture/PIE";</script><meta name="MobileOptimized" content="width">
<meta name="HandheldFriendly" content="true">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta http-equiv="cleartype" content="on">
<meta http-equiv="X-UA-Compatible" content="IE=edge, chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1">  <link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_1GNyRpZHO3E-24dlIHLswzc3F5q0aAQV4xnRKiyxIZs.css" media="all" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_E_m1hLya0xZvHdWtIu4nWT5FEFKCTruwNcVf42I6LH0.css" media="all" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_MC7tw1Qe-2mNtXMo9YUH4PQZ9-cAXlJkRJ5ORuUDdSQ.css" media="all" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/all/modules/popup/popup.css?mxqna3" media="all" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_4KiOb7zHZMJ2q6pGMG7e8QOqzUE86brt7RZ8H9N6STU.css" media="all" />
<style type="text/css" media="all">
<!--/*--><![CDATA[/*><!--*/
.sexybookmarks-block-sexybookmarks-current ul.shr-socials li.shareaholic{background-image:url('http://www.mousewheel.net/sites/default/files/touchpro/sexybookmarks/f58189b2289472fd380ede5f9b921109/sprite.png') !important;}

/*]]>*/-->
</style>
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/all/modules/popup/styles/white/popup-element.css?mxqna3" media="screen, projection" />
<style type="text/css" media="all">
<!--/*--><![CDATA[/*><!--*/
.sexybookmarks-block-sexybookmarks-current ul.shr-socials li.shareaholic{background-image:url('http://www.mousewheel.net/sites/default/files/touchpro/sexybookmarks/f58189b2289472fd380ede5f9b921109/sprite.png') !important;}

/*]]>*/-->
</style>
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_s5FhfjS9D7-WRupyNkhIuI4zK_SJ01QHoqH9JHidZxE.css" media="all" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_47DEQpj8HBSa-_TImW-5JCeuQeRkm5NMpJWZG3hSuFU.css" media="all" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_I-uZ8lsCQyPe6LPKl1QSTd29fGOsoCk7i9SJ7XZMXRI.css" media="screen" />
<link type="text/css" rel="stylesheet" href="http://www.mousewheel.net/sites/default/files/touchpro/css/css_6j_kM_lFBpjKiiMCcWiOeu7BL5nIp-9slDeauzjyeCM.css" media="all" />
  <!--[if (lt IE 9) ]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]--><!--[if (lt IE 9) & (!IEMobile)]><script src="/sites/all/themes/arctica/arctica/scripts/polyfills/respond.min.js"></script><![endif]-->  <script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_LQs_433FnKjvOwD836BIatQ97Nx8jZdBG3xT6XM2o5g.js"></script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_wMq06n34El81cPtKvKVuAehyOEwepE71d1W2gGcEjDE.js"></script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_Wzj0zXNqjdb5Udsixz9irXuVURdQRxrfpxwtrNZ8Dc8.js"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
if(window.addEventListener){window.addEventListener("load",function(){setTimeout(function(){window.scrollTo(0,0.9)},0)});}
//--><!]]>
</script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_tNQxyyT0T1w2mp8RC51cl8IYyoLLEewuOmV_C5cNxy8.js"></script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/all/modules/popup/popup.js?mxqna3"></script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_ZPMVUwauT3CzfUSIYk-Kc3nwhp80i90VcKjYuHm5owQ.js"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
SHRSB_Globals = {"perfoption":"0"};
//--><!]]>
</script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
SHRSB_Settings = {};
//--><!]]>
</script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_xpcUaefRF16dGRM12CceyhwGxO2jTZMKo_3milCSqpk.js"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
var text_resize_scope = "main";
    var text_resize_minimum = "12";
    var text_resize_maximum = "25";
    var text_resize_line_height_allow = 1;
    var text_resize_line_height_min = "16";
    var text_resize_line_height_max = "36";
//--><!]]>
</script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_qobnfzlTECZCjPtvaXNaAxoH_7HruIyNbQd9TZKKwwc.js"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
jQuery.extend(SHRSB_Settings, {"sexybookmarks-block-sexybookmarks-current":{"service":"5,7,236,257,207","fbLikeButton":false,"fbButtonPos":"bottom-left","dontShowShareCount":true,"designer_toolTips":true,"tip_bg_color":"#000000","tip_text_color":"#FFFFFF","rel":"nofollow","target":"_blank","shrlink":false,"shortener":"google","twitter_template":"${title} - ${short_link} @mousewheel.net","expand":true,"center":false,"spaced":false,"apikey":"19afe428dd0d6406b366252cf4204ec6e","src":"http:\/\/www.mousewheel.net\/sites\/default\/files\/touchpro\/sexybookmarks\/f58189b2289472fd380ede5f9b921109","link":"","title":"Database Drupal API examples | Mouse Wheel","notes":"","localize":true}});
//--><!]]>
</script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
jQuery.extend(SHRSB_Settings, {"sexybookmarks-block-sexybookmarks-current":{"service":"5,7,236,257,207","fbLikeButton":false,"fbButtonPos":"bottom-left","dontShowShareCount":true,"designer_toolTips":true,"tip_bg_color":"#000000","tip_text_color":"#FFFFFF","rel":"nofollow","target":"_blank","shrlink":false,"shortener":"google","twitter_template":"${title} - ${short_link} @mousewheel.net","expand":true,"center":false,"spaced":false,"apikey":"19afe428dd0d6406b366252cf4204ec6e","src":"http:\/\/www.mousewheel.net\/sites\/default\/files\/touchpro\/sexybookmarks\/f58189b2289472fd380ede5f9b921109","link":"","title":"Database Drupal API examples | Mouse Wheel","notes":"","localize":true}});
//--><!]]>
</script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_XspvgBpdFxndsBn-A3ExnUewnkpIgc1ShNslOBiS82Y.js"></script>
<script type="text/javascript" src="http://www.mousewheel.net/sites/default/files/touchpro/js/js_jx1xW_TYYqe5cfcMM_YsuDE50KZMsYjxX9TTz5i8VTg.js"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
jQuery.extend(Drupal.settings, {"basePath":"\/","pathPrefix":"","cssfuture":{"piePath":"\/sites\/all\/themes\/arctica\/arctica\/features\/arctica-cssfuture\/PIE\/"},"slideshowKit":{"flexInvoke":".region-featured article .content","flexAnimation":"1","flexTimeout":"7500","flexSpeed":"1800","flexRandom":"0","flexPause":"1","flexShowPager":"1","flexPrevNext":"1"},"sooperfish":{"invoke":".primary-menu \u003E ul.menu","delay":"500","dualColumn":"5","tripleColumn":"12","sooperfishWidth":"200","speedShow":"400","easingShow":"easeOutTurbo2","speedHide":"400","easingHide":"easeOutTurbo2","animationShow":{"height":"show"},"animationHide":{"height":"hide"}},"ajaxPageState":{"theme":"touchpro","theme_token":"BfZyc3mPMQqUiYEtCkBDReKVNA1w8QvhI62yOUkCuyI","js":{"sites\/all\/themes\/arctica\/arctica\/features\/arctica-layoutkit\/ori-scale.min.js":1,"misc\/jquery.js":1,"misc\/jquery.once.js":1,"misc\/drupal.js":1,"sites\/all\/libraries\/prettify\/prettify.js":1,"sites\/all\/modules\/custom\/selecttext.js":1,"0":1,"sites\/all\/themes\/tundra\/tundra\/features\/sooper-slideshowkit\/jquery.flexslider.js":1,"sites\/all\/themes\/tundra\/tundra\/features\/sooper-slideshowkit\/invoke-flexslider.js":1,"sites\/all\/themes\/tundra\/tundra\/scripts\/jquery.easing-sooper.js":1,"sites\/all\/themes\/tundra\/tundra\/features\/sooper-dropdownkit\/jquery.sooperfish.min.js":1,"sites\/all\/themes\/tundra\/tundra\/features\/sooper-dropdownkit\/invoke-sooperfish.js":1,"sites\/all\/libraries\/colorbox\/colorbox\/jquery.colorbox-min.js":1,"sites\/all\/modules\/colorbox\/js\/colorbox.js":1,"sites\/all\/modules\/colorbox\/styles\/default\/colorbox_default_style.js":1,"sites\/all\/modules\/colorbox\/js\/colorbox_load.js":1,"sites\/all\/modules\/popup\/popup.js":1,"sites\/all\/modules\/prettify\/prettify.loader.js":1,"1":1,"2":1,"sites\/all\/modules\/text_resize\/jquery.cookie.js":1,"3":1,"sites\/all\/modules\/text_resize\/text_resize.js":1,"sites\/all\/modules\/extlink\/extlink.js":1,"sites\/all\/modules\/custom_search\/custom_search.js":1,"4":1,"5":1,"public:\/\/sexybookmarks\/jquery.shareaholic-publishers-sb.min.js":1,"sites\/all\/modules\/permalink_block\/selecttext.js":1,"sites\/all\/themes\/touchpro\/scripts\/jquery.overlabel.js":1},"css":{"modules\/system\/system.base.css":1,"sites\/all\/modules\/autofloat\/autofloat.css":1,"sites\/all\/modules\/custom\/permalink.css":1,"sites\/all\/modules\/date\/date_api\/date.css":1,"sites\/all\/modules\/domain\/domain_nav\/domain_nav.css":1,"modules\/field\/theme\/field.css":1,"sites\/all\/modules\/stickynote\/css\/stickynote.css":1,"sites\/all\/modules\/views\/css\/views.css":1,"sites\/all\/modules\/permalink_block\/permalink_block.css":1,"sites\/all\/themes\/arctica\/arctica\/styling\/css\/arctica.reset.css":1,"sites\/all\/themes\/arctica\/arctica\/features\/arctica-visual-bootstrap\/css\/forms.css":1,"sites\/all\/themes\/arctica\/arctica\/features\/arctica-visual-bootstrap\/css\/navigation.css":1,"sites\/all\/themes\/arctica\/arctica\/features\/arctica-visual-bootstrap\/css\/messages.css":1,"sites\/all\/themes\/arctica\/arctica\/features\/arctica-visual-bootstrap\/css\/print.css":1,"sites\/all\/themes\/arctica\/arctica\/features\/arctica-layoutkit\/arctica-easygrid\/arctica-easy-grid.css":1,"system.menus.css":1,"system.messages.css":1,"system.theme.css":1,"comment.css":1,"user.css":1,"search.css":1,"taxonomy.css":1,"poll.css":1,"book.css":1,"node.css":1,"sites\/all\/modules\/colorbox\/styles\/default\/colorbox_default_style.css":1,"sites\/all\/modules\/ctools\/css\/ctools.css":1,"sites\/all\/modules\/popup\/popup.css":1,"sites\/all\/modules\/text_resize\/text_resize.css":1,"sites\/all\/modules\/extlink\/extlink.css":1,"0":1,"sites\/all\/modules\/popup\/styles\/white\/popup-element.css":1,"1":1,"public:\/\/sexybookmarks\/f58189b2289472fd380ede5f9b921109\/sprite.css":1,"sites\/all\/modules\/flickr\/flickr.css":1,"sites\/all\/themes\/arctica\/arctica\/styling\/css\/arctica.base.css":1,"sites\/all\/themes\/arctica\/arctica\/remove\/twitter-pull-listing.css":1,"sites\/all\/themes\/touchpro\/styling\/css\/style.css":1,"sites\/default\/files\/touchpro\/arctica-cache-touchpro.css":1,"sites\/all\/themes\/touchpro\/color\/color_module.css":1,"sites\/all\/libraries\/prettify\/prettify.css":1}},"colorbox":{"opacity":"0.85","current":"{current} of {total}","previous":"\u00ab Prev","next":"Next \u00bb","close":"Close","maxWidth":"100%","maxHeight":"100%","fixed":true,"__drupal_alter_by_ref":["default"]},"jcarousel":{"ajaxPath":"\/jcarousel\/ajax\/views"},"popup":{"effects":{"show":{"default":"this.body.show();","fade":"\n        if (this.opacity){\n          this.body.fadeTo(\u0027medium\u0027,this.opacity);\n        }else{\n          this.body.fadeIn(\u0027medium\u0027);\n        }","slide-down":"this.body.slideDown(\u0027medium\u0027)","slide-down-fade":"\n        this.body.animate(\n          {\n            height:\u0027show\u0027,\n            opacity:(this.opacity ? this.opacity : \u0027show\u0027)\n          }, \u0027medium\u0027\n        );"},"hide":{"default":"this.body.hide();","fade":"this.body.fadeOut(\u0027medium\u0027);","slide-down":"this.body.slideUp(\u0027medium\u0027);","slide-down-fade":"\n        this.body.animate(\n          {\n            height:\u0027hide\u0027,\n            opacity:\u0027hide\u0027\n          }, \u0027medium\u0027\n        );"}},"linger":250},"prettify":{"linenums":false,"match":".content","nocode":"no-code","custom":[],"markup":{"code":true,"pre":true,"precode":true}},"extlink":{"extTarget":"_blank","extClass":"ext","extSubdomains":0,"extExclude":"","extInclude":"","extAlert":0,"extAlertText":"This link will take you to an external web site. We are not responsible for their content.","mailtoClass":"mailto"},"custom_search":{"form_target":"_self","solr":0}});
//--><!]]>
</script>
<!-- Start of Woopra Code -->
<script type="text/javascript">
function woopraReady(tracker) {
    tracker.setDomain('ssthistlegorm.com');
    tracker.setIdleTimeout(300000);
    tracker.track();
    return false;
}
(function() {
    var wsc = document.createElement('script');
    wsc.src = document.location.protocol+'//static.woopra.com/js/woopra.js';
    wsc.type = 'text/javascript';
    wsc.async = true;
    var ssc = document.getElementsByTagName('script')[0];
    ssc.parentNode.insertBefore(wsc, ssc);
})();
</script>
<!-- End of Woopra Code -->
</head>
<body class="html not-front not-logged-in one-sidebar sidebar-second page-node page-node- page-node-424 node-type-page domain-www-mousewheel-net i18n-en" >
  <div class="bg-gradient"></div><div class="bg-image"></div>  <div id="skip-link">
    <a href="#main-content" class="element-invisible element-focusable">Skip to main content</a>
  </div>
  <div id="fb-root"></div><script type="text/javascript">
     window.fbAsyncInit = function() {
       FB.init({
         appId: "182804048434364",
         status: true,
         cookie: true,
         xfbml: true,
         oauth : true,
         channelUrl: "http:\/\/www.mousewheel.net\/fb_social\/channel"
         });
  
         
     };
     (function() {
       var e = document.createElement('script');
       e.async = true;
       e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js';
       document.getElementById('fb-root').appendChild(e);
     }());
  </script>  
  <header role="banner" class="masthead clearfix">
    <div class="mast">
      <div class="logo-container">
                  <h1 class="site-name grid-inner">
            <a href="/" title="Home" rel="home">Mouse Wheel</a>
                  <a href="/" title="Home" rel="home" class="logo grid-inner">
            <img src="http://www.mousewheel.net/sites/default/files/touchpro/logo5.png" alt="Home" />
          </a>
                  </h1>
                          <h2 class="site-slogan grid-inner">Drupal Examples Explained</h2>
              </div> <!-- end .logo-container -->

      
              <nav class="grid-inner primary-menu" role="navigation">
          <ul class="menu"><li class="first leaf"><a href="/showcases" title="Demo&#039;s explained">Showcases</a></li>
<li class="leaf"><a href="/gems" title="Links to precious posts on Drupal.org">Gems</a></li>
<li class="leaf"><a href="/bluehost" title="Setup on a shared host">Bluehost</a></li>
<li class="leaf"><a href="/non-drupal" title="Useful info that&#039;s not Drupal related">Non-Drupal</a></li>
<li class="last leaf"><a href="http://about.me/martin.postma" title="Profile of Martin Postma (lolandese)">About</a></li>
</ul>        </nav>
      
          </div><!-- end .mast -->
  </header>

  <div id="page" class="mast">

    
          <nav class="breadcrumb grid-inner"><div class="breadcrumb"><a href="/">Home</a> &raquo; Database Drupal API examples</div></nav>
    
    
    <div class="wrap-columns clearfix">

      <div class="content-column">
        <div role="main" class="main">
                <a class="main-content"></a>
                                        <h1 class="title page-title grid-inner">Database Drupal API examples</h1>                
  <section class="region region-help">
    <article id="block-text-resize-0" class="block block-text-resize media-1-grid-100 block-text_resize first last">
  <div class="grid-inner">
      <div class="block-content content">
      <a href="javascript:;" class="changer" id="text_resize_decrease"><sup>-</sup>A</a> <a href="javascript:;" class="changer" id="text_resize_increase"><sup>+</sup>A</a><div id="text_resize_clear"></div>    </div>
  </div>
</article>
  </section>
                
  <section class="region region-content">
    <article id="block-system-main" class="block block-system block-system first ">
  <div class="grid-inner">
      <div class="block-content content">
      <article id="node-424" class="node node-page node-promoted clearfix" about="/database-drupal-api-examples" typeof="foaf:Document">

  
  <div class="content clearfix">
  
      <header class="author">
            <span property="dc:date dc:created" content="2013-09-10T22:35:09+02:00" datatype="xsd:dateTime" rel="sioc:has_creator">Submitted by <a href="/users/lolandese" title="View user profile." class="username" xml:lang="" about="/users/lolandese" typeof="sioc:UserAccount" property="foaf:name">lolandese</a> on Tue, 10/09/2013 - 22:35</span>    </header>
      <div class="field field-name-body field-type-text-with-summary field-label-hidden"><div class="field-items"><div class="field-item even" property="content:encoded"><p><span style="font-size:14px;">The Drupal 7 Database API provides a standard, vendor-agnostic abstraction layer for accessing database servers. The API is designed to preserve the syntax and power of SQL as much as possible, but also to:</span></p>
<ul dir="ltr"><li style="line-height: 1.15; margin-top: 0pt; margin-bottom: 0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">support multiple database servers easily;</span></span></span></li>
<li style="line-height: 1.15; margin-top: 0pt; margin-bottom: 0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">allow developers to leverage more complex functionality, such as transactions;</span></span></span></li>
<li style="line-height: 1.15; margin-top: 0pt; margin-bottom: 0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">provide a structured interface for the dynamic construction of queries;</span></span></span></li>
<li style="line-height: 1.15; margin-top: 0pt; margin-bottom: 0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">enforce security checks and other good practices;</span></span></span></li>
<li style="line-height: 1.15; margin-top: 0pt; margin-bottom: 0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">provide modules with a clean interface for intercepting and modifying a site's queries.</span></span></span></li>
</ul><p><span style="background-color: transparent; font-family: Arial; font-size: 14px; line-height: 1.15; white-space: pre-wrap;">Here are examples of some Drupal database API functions.</span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;">
<!--break--></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Simple select query:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT * FROM users;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$results </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Select selected columns:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT uid, uname, mail FROM users;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, array(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uname'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'mail'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">));</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$results </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Add column on conditions to select query:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">    </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">   </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uname'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">    </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'mail'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$results </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Calculated Columns:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT uid, name, CONCAT(CAST(uid as CHAR), name, mail) as newc FROM users;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">   </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">   </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'name'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">    </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addExpression</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'CONCAT(CAST(uid as CHAR), name, mail)'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'newc'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$results </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Conditional select - conditon($field, $value, $operator) - $operator is default "=" if "IN" then $value should be an array :</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT * FROM user where uid = 5</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">5</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Use "AND" and "OR" in where conditions:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT * FROM users WHERE uid =5 OR mail LIKE '%<a href="&#109;&#97;&#105;&#108;&#116;&#111;&#58;&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;">&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;</a>'</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_or</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">          </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">5</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">          </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'mail'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'%misterx.gmail.com'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'LIKE'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Use both "AND" and "OR" in where condition:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT * FROM users WHERE ( uid =5 OR name LIKE '%misterx%') AND (mail = '<a href="&#109;&#97;&#105;&#108;&#116;&#111;&#58;&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#104;&#101;&#114;&#101;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;">&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#104;&#101;&#114;&#101;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;</a>')</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_or</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">         </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">5</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">         </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'name'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'%misterx%'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'LIKE'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$conditions</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'mail'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">,</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'<a href="&#109;&#97;&#105;&#108;&#116;&#111;&#58;&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#104;&#101;&#114;&#101;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;">&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#104;&#101;&#114;&#101;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;</a>'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Sub-query:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT name FROM users WHERE uid IN ( SELECT uid FROM users WHERE uid &lt;&gt; 0);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$subquery </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">          </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$subquery</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">          </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$subquery</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">codition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'0'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'&lt;&gt;'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'name'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$subquery</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'IN'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Joining:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT N.type, N.title, U.name, F.field_first_name_value FROM node N, user U, field_data_first_name F WHERE N.nid = F.entity_id AND N.uid = U.uid AND U.uid = 1</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'node'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'N'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'N'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, array(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'type'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'title'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">));</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addJoin</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'INNER'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'U'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'N.uid = U.uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addJoin</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'INNER'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'field_data_first_name'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'F'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'N.nid = F.entity_id'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'U'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'name'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">addField</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'F'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'field_first_name_value'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'U.uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">1</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">I</span></span><span style="background-color: transparent; font-family: Arial; white-space: pre-wrap; line-height: 1.15;">nsert query:</span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">INSERT INTO variables (name, value) values('misterx', '2');</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_insert</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'variables'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">( array(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'name' </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">=&gt; </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'misterx'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'value' </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">=&gt; </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'2'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">));</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Update query:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">UPDATE users SET mail='<a href="&#109;&#97;&#105;&#108;&#116;&#111;&#58;&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;">&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;</a>' WHERE uid =2</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_update</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'users'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">( array(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'mail' </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">=&gt; </span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'<a href="&#109;&#97;&#105;&#108;&#116;&#111;&#58;&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;">&#109;&#105;&#115;&#116;&#101;&#114;&#120;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;</a>'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">));</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'uid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">2</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> </p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><strong><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">Delete query:</span></span></strong></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; background-color: transparent; white-space: pre-wrap;">DELETE FROM node WHERE nid = 3</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_delete</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'node'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">       </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">condition</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'nid'</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">3</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span style="font-size:14px;"><span id="docs-internal-guid-0aae0a54-098c-e2ce-181d-ef9e939c35fc"><span style="font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></span></p>
<div> </div>
<div><span style="font-size:14px;"><strong>Conactenation again:</strong></span></div>
<div><span id="docs-internal-guid-0aae0a54-0c06-1e4d-e229-777ede25f64e"><span style="font-size: 15px; font-family: Arial; background-color: transparent; white-space: pre-wrap;">SELECT * FROM mytable WHERE CONCAT(mytable.name,mytable.tel) LIKE %value%</span></span></div>
<div>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c08-ba05-57db-ef558de844b8"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">&lt;?php</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c08-ba05-57db-ef558de844b8"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">db_select</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'node'</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-size: 15px; font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c08-ba05-57db-ef558de844b8"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">   </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">Fields</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'u'</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c08-ba05-57db-ef558de844b8"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">   </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">where</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">"concat(title, type) like '%'"</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, array());</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c08-ba05-57db-ef558de844b8"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">   </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">execute</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">()-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAll</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></p>
<p><span id="docs-internal-guid-0aae0a54-0c08-ba05-57db-ef558de844b8"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></p>
<p><span style="font-size:14px;"><strong>php$record = $result-&gt;fetch:</strong></span><br /><span style="background-color: transparent; color: rgb(0, 0, 187); font-family: Arial; font-size: 15px; white-space: pre-wrap; line-height: 1.15;">&lt;?php</span><br /><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$record </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetch</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();            </span><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Use the default fetch mode.</span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$record </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchObject</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();  </span><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Fetch as a stdClass object.</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$record </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAssoc</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();   </span><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Fetch as an associative array.</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Retrieve all records into an indexed array of stdClass objects.</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAll</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Retrieve all records into an associative array keyed by the field in the result specified.</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAllAssoc</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$field</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Retrieve a 2-column result set as an associative array of field 1 =&gt; field 2.</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAllKeyed</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// You can also specify which two fields to use by specifying the column numbers for each field</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAllKeyed</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">0</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">,</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">2</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">); </span><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// would be field 0 =&gt; field 2</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchAllKeyed</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">1</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">,</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">0</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">); </span><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// would be field 1 =&gt; field 0</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Retrieve a 1-column result set as one single array.</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchCol</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// Column number can be specified otherwise defaults to first column</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">fetchCol</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$column_index</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">//To count the number of Rows returned use:</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">number_of_rows </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">= </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$result</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">rowCount</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">();</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// range</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">$query</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">range</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">0</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">50</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">);</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(255, 128, 0); background-color: transparent; white-space: pre-wrap;">// order by</span></span></p>
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">query</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">-&gt;</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">orderBy</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">(</span><span style="font-size: 15px; font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'n.created'</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">, </span><span style="font-size: 15px; font-family: Arial; color: rgb(221, 0, 0); background-color: transparent; white-space: pre-wrap;">'DESC'</span><span style="font-size: 15px; font-family: Arial; color: rgb(0, 119, 0); background-color: transparent; white-space: pre-wrap;">)</span></span></p>
<p><span id="docs-internal-guid-0aae0a54-0c09-d760-831a-2435a4484309"><span style="font-size: 15px; font-family: Arial; color: rgb(0, 0, 187); background-color: transparent; white-space: pre-wrap;">?&gt;</span></span></p>
</div>
</div></div></div><div class="fb-social-comments-plugin">
  <div  class="fb-comments" data-numposts="10" data-width="550" data-colorscheme="light" data-migrated="0" data-href="http://www.mousewheel.net/database-drupal-api-examples"></div>
</div>

<ul style="display:none"></ul>  </div>

      <footer class="link-wrapper clearfix">
      <ul class="links inline"><li class="statistics_counter first last"><span>680 reads</span></li>
</ul>      <div class="field field-name-field-category field-type-taxonomy-term-reference field-label-hidden"><div class="field-items"><div class="field-item even"><a href="/showcases">Showcases</a></div></div></div>    </footer>
  
  
</article>    </div>
  </div>
</article>
<article id="block-permalink-block-permalink-copybox" class="block block-permalink-block block-permalink_block  ">
  <div class="grid-inner">
      <div class="block-content content">
      
  <div id="popup-element-0" class="popup-element popup-element-noscript popup-style-white activate-hover effect-fade expand-top-right origin-top-left">
  <a  class="popup-element-title"><span>Permalink</span></a>  <div class="popup-element-body expand-top-right origin-top-left width-500">
    <table class="popup-layout">
    <tr class="top"><td class="left"></td><td class="center"></td><td class="right"></td></tr>
    <tr class="center">
      <td class="left"></td>
      <td class="center">
        <div class="inner">
                    <div id="permalink"><div class="intro">HTML code to copy to your site or email message:</div><div class="help">Click below to select, Ctrl + C to copy.</div><br /><div id="copybox" onclick="selectText('copybox')">&lt;a href=&quot;http://www.mousewheel.net/node/424&quot; title=&quot;mousewheel.net, drupal examples explained&quot;&gt;Database Drupal API examples&lt;/a&gt;</div></div>         </div>
      </td>
      <td class="right"></td>
    </tr>
    <tr class="bottom"><td class="left"></td><td class="center"></td><td class="right"></td></tr>
  </table>

</div>


</div>    </div>
  </div>
</article>
<article id="block-sexybookmarks-current" class="block block-sexybookmarks media-1-grid-2-3 block-sexybookmarks  last">
  <div class="grid-inner">
      <div class="block-content content">
      <div class='sexybookmarks-wrapper'><div class='sexybookmarks-block-sexybookmarks-current'></div></div>    </div>
  </div>
</article>
  </section>
                <div class="feed-icons grid-inner"></div>
        </div> <!-- end .main -->
      </div> <!-- end .content-column -->

            
  <section class="region region-sidebar-second">
    
<nav id="block-views-popular-block" class="block block-views block-views first last grid-inner">
                  <header><h2 class="block-title">Most popular</h2></header>
          
    <div class="view view-popular view-id-popular view-display-id-block view-dom-id-d84edee38116bff9c4efe56cce52f916">
        
  
  
      <div class="view-content">
      <div class="item-list">    <ul>          <li class="views-row views-row-1 views-row-odd views-row-first">  
  <span class="views-field views-field-title">        <span class="field-content"><a href="/flickr-colorbox-integration-drupal-7-auto-float-images-text-body-alternately-right-and-left">Flickr-Colorbox integration in Drupal 7 &amp; auto float images in text body alternately right and left.</a></span>  </span></li>
          <li class="views-row views-row-2 views-row-even">  
  <span class="views-field views-field-title">        <span class="field-content"><a href="/blog-vs-static-business-website">A blog vs a static business website</a></span>  </span></li>
          <li class="views-row views-row-3 views-row-odd">  
  <span class="views-field views-field-title">        <span class="field-content"><a href="/automatically-convert-online-price-list-multiple-currencies">Automatically convert an online price list in multiple currencies</a></span>  </span></li>
          <li class="views-row views-row-4 views-row-even">  
  <span class="views-field views-field-title">        <span class="field-content"><a href="/sea-queen-fleet">Sea Queen Fleet</a></span>  </span></li>
          <li class="views-row views-row-5 views-row-odd views-row-last">  
  <span class="views-field views-field-title">        <span class="field-content"><a href="/create-multilingual-menus">Create multilingual menus</a></span>  </span></li>
      </ul></div>    </div>
  
  
  
  
  
  
</div></nav>
  </section>

    </div> <!-- end .wrap-columns -->

    
  </div> <!-- end #page -->

        <!--[if (lt IE 8) ]><script src="/sites/all/themes/arctica/arctica/scripts/polyfills/imgSizer.min.js"></script><![endif]--><div style="display:none">glqxz9283 sfy39587stf02 mnesdcuix8</div><div style="display:none">glqxz9283 sfy39587stf03 mnesdcuix8</div><div style="display:none">glqxz9283 sfy39587stf04 mnesdcuix8</div></body>
</html>

<!-- Page cached by Boost @ 2014-01-15 09:45:30, expires @ 2014-01-15 10:45:30, lifetime 1 hour -->